How to find the Nth maximum and minimum value in sqlserver.

Question

Anonymous User · Answer

DECLARE @table TABLE(ID integer,AMOUNT integer)INSERT INTO @table values(1, 5000)INSERT INTO @table values(2, 200)INSERT INTO @table values(3, 4500)INSERT INTO @table values(4, 3000)INSERT INTO @table values(5, 3200)INSERT INTO @table values(6, 3100)INSERT INTO @table values(7, 150) 
SELECT ID, AMOUNTFROM(SELECT ID, AMOUNT, Row_Number() OVER(ORDER BY AMOUNT DESC) AS highestFROM @table) as xWHERE highest = 1SELECT id, AMOUNT
FROM(
SELECT id, amount, Row_Number() OVER(ORDER BY AMOUNT ASC) AS lowest
FROM @table
) as x
WHERE lowest =1and

forum

How to find the Nth maximum and minimum value in sqlserver.

Anonymous User

Can you answer this question?

1 Answers

Liked By